﻿IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RA_Lists]') AND type in (N'U'))
DROP TABLE [dbo].[RA_Lists]
go

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RA_Lists](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [varchar](255) NOT NULL,
	[creationDate] [datetime] NOT NULL CONSTRAINT [DF_RA_Lists_creationDate]  DEFAULT (getdate()),
	[groupId] [int] NOT NULL,
	[isUserBased] [bit] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF